Recommended Practices for Spreadsheet Testing
نویسنده
چکیده
This paper presents the author’s recommended practices for spreadsheet testing. Documented spreadsheet error rates are unacceptable in corporations today. Although improvements are needed throughout the systems development life cycle, credible improvement programs must include comprehensive testing. Several forms of testing are possible, but logic inspection is recommended for module testing. Logic inspection appears to be feasible for spreadsheet developers to do, and logic inspection appears to be safe and effective.
منابع مشابه
Spreadsheet Engineering: A Research Framework
Spreadsheet engineering adapts the lessons of software engineering to spreadsheets, providing eight principles as a framework for organizing spreadsheet programming recommendations. Spreadsheets raise issues inadequately addressed by software engineering. Spreadsheets are a powerful modeling language, allowing strategic rapid model change, and enabling exploratory modeling. Spreadsheets users l...
متن کاملResearch Strategy and Scoping Survey on Spreadsheet Practices
We propose a research strategy for creating and deploying prescriptive recommendations for spreadsheet practice. Empirical data on usage can be used to create a taxonomy of spreadsheet classes. Within each class, existing practices and ideal practices can he combined into proposed best practices for deployment. As a first step we propose a scoping survey to gather non-anecdotal data on spreadsh...
متن کاملInclusion Analysis
Inclusion analysis is the name given by Operis to a black box testing technique that it has found to make the checking of key financial ratios calculated by spreadsheet models quicker, easier and more likely to find omission errors than code inspection. 1 CALCULATE MORE THAN ONCE One approach among many [Pryor, 2004] [Panko, 2006] for improving the chance that a spreadsheet delivers the results...
متن کاملSpreadsheet Knowledge and Skills of French Secondary School Students
The aim of our research project called DidaTab – Didactics of Spreadsheets – is to get a more comprehensive picture of ICT uses in French schools and to obtain a better knowledge of students’ spreadsheet competencies. The exploratory study of curricula and practices shows very sparse use during secondary education. To achieve a more precise estimation of what students can do with spreadsheets, ...
متن کاملTeaching Spreadsheets: Curriculum Design Principles
EuSpRIG concerns direct researchers to revisit spreadsheet education, taking into account error auditing tools, checklists, and good practices. This paper aims at elaborating principles to design a spreadsheet curriculum. It mainly focuses on two important issues. Firstly, it is necessary to establish the spreadsheet invariants to be taught, especially those concerning errors and good practices...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید
ثبت ناماگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید
ورودعنوان ژورنال:
- CoRR
دوره abs/0712.0109 شماره
صفحات -
تاریخ انتشار 2006